Creating four Line and Stacked Column Charts 16

Attrition by Department - Line and Stacked Column Chart:

1. Chart Configuration:

Set the X-axis to "Department".
For the Column Y-axis, use the count of ‘Status’. The ‘Status’ is a calculated field derived from the ‘Left’ field, where 0 indicates 'Employed' and 1 indicates 'Left' (departure from the company).
Set the Line Y-axis to display the ‘Attrition %’ and ‘Satisfaction %’ measures. Ensure both are formatted as percentages with 0 decimal places.
Set the legend to ‘Status’ again for clarity and cohesiveness with the data represented.

2. Chart Dimensions and Placement: Select the "Line and Stacked Column Chart" from the Visualizations pane. Set the height and width to 301x344. Position the chart at Horizontal: 181 and Vertical: 86 on your dashboard.

3. Formatting:

Edit the chart title to ‘Attrition by Department’ using DIN font, size 14, color black, and background color #C7D4E8.
Enable the legend but disable the legend title for a cleaner look.
Disable the chart background to maintain focus on the data.
Enable a visual border with the color #999999.
Configure X-axis and Y-axis values with Segoe font, size 9, and color black. Disable titles for both axes to simplify the visual presentation.
Turn off all gridlines for a neater chart appearance.
Sort the legend (Status) in descending order for intuitive data comprehension.
Customize the column colors: set ‘Left’ to #41A4FF and ‘Employed’ to #4E79A7.
Adjust the line stroke width to 3x for visibility. Set the line color for ‘Attrition %’ to #C5A00C and for ‘Satisfaction %’ to #4AC7B0 for distinct recognition.

4. Replicate for Additional Metrics: Copy the created chart and adjust the X-axis field to generate new charts: 'Attrition by Tenure', 'Attrition by Number of Projects', and 'Attrition by Salary', adapting each for distinct attrition insights.

5. Create Line and Stacked Column Charts for Predictive Section: Following the same process, develop four corresponding Line and Stacked Column Charts for the predictive section, selecting appropriate predictive measures and metrics for each chart. Ensure these also follow the formatting standards and color schemes established in the historical section for consistency.

6. Managing Visibility for Sections:

In the predictive section of the dashboard, select all historical charts and hide them using the Selection Pane. Then, update the predictive bookmark to save this state where only predictive charts are visible.
Conversely, in the historical section, hide all predictive charts through the Selection Pane and update the historical bookmark to reflect this setup, ensuring only historical charts display in this view. Finally, toggle between the historical and predictive bookmarks to verify the correct functionality and visibility of the charts.

Line and Stacked Column Chart in Power B